It provides the ability to handle any type of event associated with the Execution of its task and Container.
The following list of Events is more significant and commonly used.
It is generated as a result of the error condition. It falls into the category of the most frequently Implemented types of Event Handlers.
Similar to on Error Event, It raised in response to the problem.
It signals the failure of a task and typically follows on error event.
Occurs as soon as the validation Process of the component is completed.
Marks the beginning of the component validation stage. The main purpose of Validation is the Detection of Potential problems. That might prevent execution from completing successfully.
Inclined to build a profession as MSBI Developer? Then here is the blog post on, explore MSBI Training
Open Business Intelligence Development Studio --------------------->
Create a new Pkg and rename it as Event Handler. Dtsx --------------------->
In control flow drag and drop the Data Flow task and rename is as Data Flow Event Handler --------------------->
In data flow drag and drop OLEDB source configure it(Provide connection manager and select Any table from the list) --------------------->
Drag and drop OLEDB destination and make a connection from OLEDB source to destination --------------------->
Configure the destination (Provide destination connection manager and create a new table As Event handler) --------------------->
Select the Event Handler tab and set,
Execute table - Select Data flow Task Event Handler Option
Event Handler – Select on Pre-validate Option --------------------->
Drag and Drop Execute SQL Task on to Event Handler Section and it will be executed where
Ever on Pre-Validate Event is raised on the Selected execute (DFT Events Handler) --------------------->
Double click on Execute SQL Task to configure it Provide connection [Local Host. Adventure Work] --------------------->
SQL Command – Truncate [Event Handler] --------------------->
Click ok --------------------->
Execute Package
Send Mail Task is used to send an email message to the recipients via SMTP connection.
Drag And Drop Send Mail Task (dn control flow) --------------------->
Double click on Send Mail Task to configure it --------------------->
Provide the following information --------------------->
SMTR connection - Select New connection --------------------->
Provider SMTP Server Name --------------------->
Click ok
From – Provide from email Address
To – Provide To email Address
Cc – Provide Carbon copy email Address (if any)
Bcc – Provide Blind Carbon copy email Address (if any)
Subject – Text Mail
Message Source Type – Direct input
Message Source – click Browse --------------------->
Type body of Mail --------------------->
Click ok
Priority – High
Attachments – Click Browse --------------------->
Select any file to be attached to the mail and click open --------------------->
Click ok --------------------->
Execute Package
Example of SMTP Connection – ASIHXCE. Vijay it.com
Open Business Intelligence Development Studio 2005 and 2008 --------------------->
Select Project menu and select Migrate dts 2000 package option --------------------->
In the package migration wizard, click next to set, --------------------->
Source - Select Structured Storage File --------------------->
File Name – click Browse --------------------->
Select any package (.dts) and --------------------->
Click open --------------------->
Click Next --------------------->
Source - File System
Click Next --------------------->
Finally, the migrated (.dtsx) package arrives in the specified Project under SSIS Package Selection --------------------->
Execute DTS
This task is used to execute a package designed
On SQL Server 2000 Environment.
Steps to Configure Execute DTS 2000 package task
In Control flow, Drag and Drop execute DTS 2000 package task --------------------->
Double click on it and set,
Storage Location – Select a Structured Storage file
File - click Browse --------------------->
Select any package (.dts) and click open
Package Name – Specify the package name, which you would lick to
Execute it on SQL Server 2005/2008 environment --------------------->
Click ok --------------------->
Execute package
You liked the article?
Like: 0
Vote for difficulty
Current difficulty (Avg): Medium
TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills in the market.